SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505259 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505259 [ RunTime:0.002162s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362105,10589,200919,128358,584107,179983,1033643,135993,111017,961466,299559,780002,75439,565233,408342,477089,668163,898700,183291,671160,890771,24407,392585,1030727,1026955,883376,3711,494825,466189,714007,597778,221968,708325,225668,932979,896842,264921,779041,540334,1000031,387362,704249,609874,614690,523579,670700,979095,171035,411214,795899,910747,413727,1016135,12622,820335,814242,525353,100412,270929,55416) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505259 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505259 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002592s ]