SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044436 LIMIT 1 [ RunTime:0.000482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044436 [ RunTime:0.001594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (487751,866810,547612,244445,338342,737631,877466,704551,944424,895296,358747,146582,201495,99081,373152,304778,891418,738994,276644,872732,955802,756158,592179,112410,615168,251749,858788,881155,992861,792091,400767,336188,174087,276521,719173,995177,512131,754134,11587,310759,14833,425371,752380,638370,628905,610771,81976,448313,292741,878619,133049,177537,153925,942747,141224,62729,273812,209304,934964,433649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044436 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044436 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]