SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018320 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018320 [ RunTime:0.004637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001217,29253,357275,206701,533893,622750,52269,194335,188324,321853,913224,833306,511717,482300,342917,1010677,652448,382691,673834,1021061,88365,323449,330697,224401,41146,187037,645078,31375,366681,1048434,67165,1040453,49543,431617,250899,693869,960516,863931,64616,516803,634220,767344,724156,431379,837156,41311,538979,486322,707011,382075,775651,1047872,327058,443115,833980,706690,591533,616620,523702,50787) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]