SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1978 LIMIT 1 [ RunTime:0.000558s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1978 [ RunTime:0.001886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (988532,620406,456143,522375,304296,510049,1003949,308551,394340,92250,645830,415034,176700,544773,649498,492142,234263,354878,533042,206029,1047321,604699,505209,999783,386913,131427,604582,299799,673170,200040,867490,162376,309319,758088,622079,289658,737275,117039,863073,348636,731713,515528,692268,1044236,172555,535072,787687,373586,791830,109888,220896,430791,65507,873558,689551,39756,252500,388456,476350,957294) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]