SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028666 LIMIT 1 [ RunTime:0.000490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028666 [ RunTime:0.002267s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (856079,870632,475431,308706,12903,696504,126103,469398,920163,414414,1021178,549199,463005,258068,430409,146819,506645,863498,1007620,660958,548231,361703,511928,755187,86997,205395,56475,958018,465200,861236,680005,229708,789052,856442,688223,947166,121161,494149,273068,812185,351646,42702,183437,330383,834336,1013085,832886,1001,246888,15191,778917,105705,813131,875000,470158,485956,559218,392557,125634,630402) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028666 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028666 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]