SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502183 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502183 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144452,89294,415132,827181,377207,377932,178655,967608,559745,494419,891001,503233,83345,753230,745220,493238,703624,190539,170355,619806,635332,95928,142242,1023834,849072,658865,116702,425005,297227,304991,392286,992494,296698,514748,1027610,94972,420122,197046,888666,122871,734285,731962,287563,623225,28771,63099,918439,88372,1037701,478445,951372,398865,667563,860826,365222,221883,299532,889058,1014547,967950) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]