SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405919 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405919 [ RunTime:0.003105s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (694792,133708,1037235,392074,57547,850601,30880,36037,480968,915602,868619,705522,63324,667172,601677,175117,879618,816832,483860,555066,465947,683691,785355,395521,821175,567194,553721,118813,1025164,498114,60682,298497,60398,1032033,31370,522907,1013730,830260,422066,1033757,121676,332803,900599,176795,954751,472537,11517,880,265015,821584,774268,926626,48767,57213,951864,172535,90069,245091,834695,251822) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405919 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405919 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]