SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046650 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046650 [ RunTime:0.002860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123710,934113,713846,1027799,906324,157823,133142,392877,825740,622288,386094,628008,927085,258092,974631,977809,839057,740982,152175,775411,522133,453276,661558,880006,787810,13409,364681,856755,646364,625063,476373,913001,677982,395962,809077,638181,312015,698951,1039835,544915,648225,696142,799446,543511,927885,491106,619079,160393,781993,792908,651928,1039736,578466,532395,242123,287614,1002481,899305,437441,796071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000781s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]