SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406504 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406504 [ RunTime:0.003027s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (822362,843560,312553,867112,178213,296841,70166,242726,910003,1012018,54463,108304,306740,175983,315964,341288,501612,212196,520777,886158,834041,155918,504189,897413,881515,234226,752835,800140,204554,684886,724420,283748,1007934,689634,59547,785507,927148,909438,473467,781611,800571,974123,535522,553063,244608,962938,68892,380115,320682,613697,846391,867844,955227,447750,527048,279301,674818,545311,111560,933602) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001167s ]