SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001664s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419347 LIMIT 1 [ RunTime:0.000540s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419347 [ RunTime:0.001966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (397554,1020529,964944,860745,898698,670207,778314,572309,79497,251774,1006394,444885,254841,160292,868023,56618,819487,208914,640144,509221,692506,601874,208506,653968,431010,915432,523965,802590,644107,776472,811159,252672,477966,1022767,414987,384990,928849,492779,512585,675196,590509,164986,467933,340184,62984,278955,491324,632712,774552,724401,168801,655857,19283,185317,982323,300104,705890,523424,876300,928002) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419347 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000660s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419347 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001069s ]