SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493391 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493391 [ RunTime:0.001442s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (159314,170840,652687,1023803,64332,400690,239922,149039,782052,755720,937031,452594,457835,963613,977498,1019271,815350,506260,421371,628578,496054,532173,874514,467479,236243,66999,116181,334947,486257,712141,815718,118958,220535,666948,505600,1015311,616448,503050,477892,959818,661743,638898,975971,796595,583880,888930,606031,686427,333811,30947,1039146,926891,372648,267731,527023,280521,718012,828429,51887,182464) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]