SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 329823 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 329823 [ RunTime:0.002107s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (594434,977938,840343,122064,218887,177047,763461,411882,941979,789469,60178,394139,1013179,714837,578380,423578,80519,1021473,896447,148920,614716,633349,1012198,757253,294683,382412,978658,38670,341147,812620,133337,78461,386992,899466,210061,320503,202401,175724,334594,249375,980312,386590,870032,43668,331723,1005361,20566,752972,546779,880562,243697,534069,911404,580248,124554,137224,181197,1031952,441540,604465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 329823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 329823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]