SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405435 LIMIT 1 [ RunTime:0.000945s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405435 [ RunTime:0.002513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439376,495742,65813,1003106,1043335,684619,759224,157443,185159,723426,892115,439841,379709,537104,908238,34354,35821,952513,1033385,669632,26167,219505,371027,889243,373134,205715,492768,236265,5116,1015219,41889,674715,893023,367810,302979,68712,624969,620363,589330,326848,680381,444488,674884,635415,129499,68984,497507,819214,939145,40519,233243,415094,814492,498363,493507,480062,61783,508033,337280,624207) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002793s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405435 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405435 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]