SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503655 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503655 [ RunTime:0.002554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529167,267611,554949,443004,217265,1036591,925474,120191,871776,243777,164979,96616,879384,627599,842706,646422,312141,352616,1034568,840903,800168,990111,396708,950776,456743,71838,309252,457737,997834,731241,118582,263776,1024930,508818,281078,773588,230922,272705,405217,717646,607537,619714,366533,425037,822532,815499,1029776,247512,248047,244526,489034,100140,994697,813290,721286,154274,448008,983043,380186,193807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503655 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503655 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]