SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 253098 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 253098 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (758111,127713,196185,775984,463340,484935,895159,464133,543095,201095,739623,933903,579805,388162,820813,719255,1018500,774789,122223,826055,962796,144825,825324,148661,229827,42029,950391,819196,373783,992648,198199,537265,931685,207839,483416,926694,117191,1008302,682917,840752,745628,151195,177382,64699,331137,576927,91686,1043748,281798,694310,953909,870671,528815,48835,787262,320885,349536,964243,624258,224466) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 253098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 253098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]