SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 819581 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 819581 [ RunTime:0.002082s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (325582,831307,119485,34684,207933,574678,121360,952295,200433,256531,508599,417525,927868,296252,160177,23059,377751,1016595,547599,355910,210371,643327,406400,368118,94145,241809,893048,547825,688629,804479,302889,552120,603355,1003263,147787,935237,337208,812191,130804,748663,898777,692394,1011530,47164,305964,917458,979651,654163,636485,631850,896670,30143,775020,348156,579431,876552,457577,594960,584724,714069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 819581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 819581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]