SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328921 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328921 [ RunTime:0.001911s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (331244,104179,1014299,439198,824341,321913,331832,177249,321661,224538,330323,714457,735451,600026,932105,948614,88992,332490,968755,568631,597851,4353,909747,783713,946650,505191,862151,609422,459863,521291,564758,797392,335931,883575,20923,778940,417077,105982,768713,606244,479977,455060,495120,441931,822070,651013,1006310,764693,260866,755340,562330,849449,384216,82760,59444,259862,328888,280117,276594,611935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001700s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328921 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328921 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]