SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507940 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507940 [ RunTime:0.002256s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40767,749357,935018,836699,131861,603837,804066,945765,785570,379153,283396,823446,176033,181115,662539,707751,53210,170872,525004,587358,206004,683065,731143,127142,152738,411919,127784,544956,790001,449094,492636,233963,354090,441165,354174,280798,876375,587104,313314,541401,715408,461799,140922,416051,540623,86711,954814,86905,661138,338416,708827,666163,781129,902611,221194,449986,191919,533180,930159,840116) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001335s ]