SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001501s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010496 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010496 [ RunTime:0.002160s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (58260,145329,562111,842334,437635,815336,4287,331590,361813,272512,191186,649764,360559,209570,461356,791789,671077,254544,129046,735781,51503,902334,101717,715312,234269,51878,473548,466634,316792,764649,504049,367052,937375,744826,931657,745305,399744,753903,745893,1012353,741438,390584,118395,813612,583692,107788,662610,248100,467543,474413,1037690,694549,1028189,135333,82091,49568,358448,809699,724814,321504) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010496 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010496 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]