SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454505 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454505 [ RunTime:0.003080s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (807354,56453,282406,938796,741660,51109,440670,943771,622495,392254,531467,691748,53685,448764,393238,617837,79913,871284,553526,914883,771413,487597,116909,648777,471341,45553,1039464,3227,257074,282776,404619,876028,853802,988517,421445,101794,373888,860714,387382,1042646,854835,204353,769574,942977,899346,727704,325668,922170,170230,89157,910601,461796,887583,939548,542099,559607,435907,271869,277021,873074) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]