SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 269930 LIMIT 1 [ RunTime:0.000476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 269930 [ RunTime:0.002465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (943128,869946,101148,618876,414074,221460,687181,892952,286878,406470,144978,378917,746302,50600,342359,1041839,167953,217142,742623,895082,9121,415370,693501,830917,905127,226043,8056,1026994,578101,1017213,1041208,279209,364688,457675,137813,483227,196258,549214,1043528,1015809,683245,986667,715788,55411,646977,960298,383434,316909,171846,52387,665374,327565,730534,897610,781185,319135,509723,703516,270697,136797) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 269930 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 269930 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]