SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453958 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453958 [ RunTime:0.001621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (778904,728118,836388,754326,880961,437907,350697,45721,8837,261291,320917,354527,698987,919007,460494,209769,231639,33432,250608,986883,512349,343142,376930,944397,687722,335184,380646,270855,57475,886089,78831,390208,352263,189436,689539,228380,686481,863533,735374,925349,65767,562812,335024,936633,442500,1001148,54091,4657,697402,444952,633492,1022221,725157,607519,577236,298046,139126,387155,171761,38133) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453958 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453958 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]