SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291897 LIMIT 1 [ RunTime:0.000560s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291897 [ RunTime:0.002289s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (43976,227276,793110,297461,1006451,166165,995601,4554,904989,805074,1011496,495477,86829,352206,66471,369398,8231,353502,858437,99042,557313,296512,1027465,1027767,546797,444225,184590,650544,360443,126775,501954,648549,665662,1010333,942892,559538,707609,345709,1040283,323888,829983,185065,356492,448844,731749,489316,907847,576370,930711,914500,898307,614843,636841,89441,441505,382935,119017,77415,306896,298747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291897 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291897 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]