SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317418 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317418 [ RunTime:0.001541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (466693,982339,411120,531347,848632,85461,771206,35823,62993,464676,218809,73155,880301,168222,152022,98609,272173,654035,880577,195858,374989,869169,166653,267547,246731,385138,806978,880606,549888,175799,827262,150583,132837,233590,111354,124321,390437,247103,344675,591401,365191,551470,833091,1034065,457899,498208,507133,218890,242690,1023552,23228,355701,575815,721334,410962,579337,60395,761722,898119,558917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]