SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 243573 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 243573 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (462290,206586,1017181,684067,854556,622120,993793,460223,610101,395860,173326,203462,798470,723176,685597,978276,739882,231242,936860,318374,687831,370708,603936,559285,782092,199505,752716,4202,754696,581202,16252,1024675,71848,1010262,267606,683928,968478,440909,851495,400836,90276,824087,78013,287436,800951,416405,569263,577284,260557,327988,692859,713546,1041877,168569,941458,602721,721013,990648,800920,1045389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 243573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 243573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]