SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536731 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536731 [ RunTime:0.001437s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (702620,912763,576533,661249,137062,626994,883617,944736,236801,959895,183280,42054,980285,742510,118619,400280,385907,411465,211,117042,427977,1024623,364011,306158,339630,807368,524821,106844,751495,463687,1039611,700232,474231,319778,595618,317902,191004,960172,844001,249235,579004,554786,535881,985115,229895,60678,279474,746647,703004,988365,803676,865900,567121,85955,531634,101234,26900,622503,1033261,106586) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536731 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536731 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]