SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001440s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100574 LIMIT 1 [ RunTime:0.000523s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100574 [ RunTime:0.001831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (373830,863708,910462,927586,51464,352579,984449,711812,173628,939174,516954,329911,572779,627957,147750,398408,750174,804558,723853,547991,718073,398633,134095,896193,171537,257636,15411,136093,84073,489875,866156,419456,670507,962791,412953,657387,54393,118735,453772,944066,507927,92418,491539,698168,629,825568,356503,751123,143322,595575,926899,532088,74118,92365,798748,633361,45098,379307,535621,725531) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100574 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100574 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000396s ]