SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54169 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54169 [ RunTime:0.002457s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (939388,285950,289484,293972,233953,449216,220731,301245,146282,285360,869116,233955,262366,925354,198776,1038830,475111,454239,1006170,933161,1030226,892184,950956,902038,99057,291026,775630,219387,166096,117047,33259,287877,263852,642350,357727,971832,53361,331489,629436,328532,750760,267093,30278,870327,1046724,532751,704277,924022,379366,261200,989259,764592,854879,384844,924009,105466,316041,22325,656941,54034) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54169 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54169 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]