SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520529 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520529 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (894402,292544,327645,812721,523489,608573,710961,468675,979842,919115,120884,384571,25658,41560,136755,62561,970152,413775,111458,976670,74699,723325,712633,74415,194881,5200,624085,512950,729616,601937,19517,738906,827193,355177,1043996,213081,319904,446859,226270,465381,879746,842014,876782,146124,567124,808880,2843,451793,327935,347032,396154,413491,576551,854314,107154,923038,281235,49988,217337,202674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]