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` = 534101 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534101 [ RunTime:0.002203s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (787531,589065,524903,98304,373679,393422,31354,877851,958096,356309,346160,361097,779522,995041,904731,134662,438144,675470,74702,66879,487510,712213,288377,146886,791205,626660,906437,2037,577665,869251,48357,282187,557713,349731,469954,505994,393984,312936,91962,14206,598186,809550,998384,343030,647044,1041867,533472,661797,908001,484614,608234,185040,292160,842494,415783,484259,356348,197731,231960,360659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001447s ]