SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002022s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414300 LIMIT 1 [ RunTime:0.003619s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414300 [ RunTime:0.005628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (466402,724673,494739,210470,1007875,781365,511371,1033523,315893,437057,791144,878431,190700,564809,823578,775033,317844,148453,69175,838713,706414,173214,148260,224839,344839,437243,524113,912898,482036,356593,890618,881191,615893,487056,829600,743818,608175,466574,952221,299810,627447,347855,214551,781834,138419,967113,176570,344390,50779,1014261,934301,961193,998790,185062,949609,297404,223898,671158,158988,766540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]