SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104573 LIMIT 1 [ RunTime:0.000706s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104573 [ RunTime:0.002083s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (860213,892121,117323,704477,848431,480811,69368,236384,372082,258988,356410,839915,687520,1021189,1005163,542158,312912,847797,555950,723979,942009,646335,796155,1041911,645221,348515,522211,96216,71762,669772,638534,752466,500766,965713,976157,488457,76096,541490,1009406,855513,1014184,839091,907143,852322,906778,573366,141209,677027,163978,469450,816075,630959,141579,746542,43522,782784,989033,917067,1015359,55514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001940s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000547s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000728s ]