SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313239 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313239 [ RunTime:0.001718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428821,554047,1021440,854046,563878,512106,459120,607552,1022753,676525,387526,559097,536965,671616,332470,413293,827993,272849,148555,505948,982534,1038656,309850,611170,1010769,944711,409630,704930,430166,873534,227086,928677,173081,646778,359909,309558,404525,599640,467997,621516,884094,541812,71187,1040973,766209,439001,621445,898526,516580,80890,903132,565050,860232,295622,499312,351236,160036,68087,325286,1000027) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313239 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000582s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313239 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001759s ]