SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447300 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447300 [ RunTime:0.001675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293066,919508,972056,1000492,457976,199461,823591,86568,68314,870910,565622,937583,1000020,196818,932799,174706,153591,234599,542889,954303,803815,281154,170124,326653,19177,145903,618126,236553,63212,42928,866325,488464,712101,934413,129677,881055,104643,724421,509778,794387,782468,158190,1037950,782466,802787,592260,233106,315671,1016796,786479,781679,552071,45622,134259,633908,146959,644366,352709,599910,21868) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001812s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001174s ]