SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502098 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502098 [ RunTime:0.001479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109869,717227,303875,1041765,899822,321043,436339,248032,593714,608071,632340,793479,413801,762374,29600,505905,767349,263276,125801,589851,877387,631634,81669,1039526,276727,988391,638178,512651,41854,545818,406262,852242,315100,799175,103536,166627,185066,592460,541897,436092,147091,78971,538153,293809,534300,981831,406935,992692,697199,691041,610991,982087,745438,24587,383906,128012,478648,595854,237508,537767) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]