SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570274 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570274 [ RunTime:0.003717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840031,390922,728421,178343,610875,871871,1016794,986141,378320,520927,1012417,615688,884446,853109,21279,64894,212813,579420,535079,501839,403565,190307,256180,134647,896175,106783,413708,914959,124772,942223,827203,612974,792935,563888,348820,734044,595670,879986,182678,337975,813231,37666,98812,97467,967046,573401,738259,49672,686825,166988,173976,905986,1013508,310525,324026,399875,941918,431652,424773,531731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570274 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570274 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002305s ]