SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001640s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036180 LIMIT 1 [ RunTime:0.000692s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036180 [ RunTime:0.002310s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282687,783263,60674,1020194,421289,91804,57231,991549,570465,228763,629150,999303,647394,15300,416808,1009809,671996,161785,358664,195057,987802,499304,83266,607150,183417,820918,237464,153924,651591,52472,258019,129282,627582,649708,74335,795157,920859,800286,126254,171322,985407,564793,281881,499178,363939,194940,236988,17822,874257,156628,963595,41814,726127,224863,446093,256214,979478,921233,732057,313133) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000611s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]