SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044375 LIMIT 1 [ RunTime:0.006732s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044375 [ RunTime:0.003670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (639268,728656,361810,854716,346144,773916,849149,353305,558119,681935,1032409,939036,340742,925120,101289,229688,312229,743849,357816,1036308,991470,930979,866750,323783,191775,665876,239740,698410,980129,1037205,347506,31662,210762,536337,369936,515232,432166,326336,61128,32370,251955,434111,619016,781064,30851,388230,618863,270059,899797,438668,507145,726767,766501,235477,752830,78381,97759,505286,748745,711251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001611s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044375 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044375 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000369s ]