SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513776 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513776 [ RunTime:0.001915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (458231,213979,683249,49830,776905,298495,257865,151610,875732,148253,566316,859980,569386,961635,111790,791963,1014348,443417,362197,450022,616953,831139,765248,840790,95899,938448,258042,37611,620382,504982,84430,591209,745204,67161,636654,555799,180282,997515,997002,760898,929624,869656,345696,661566,169860,67385,979958,951378,371544,164525,732663,177566,811527,320346,547854,918142,909787,21969,364617,231876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513776 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001576s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513776 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]