SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519904 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519904 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505600,972136,6863,1027528,837705,88232,347770,263029,733780,876701,784464,726802,88726,521705,73408,381579,964084,426247,475970,407052,730148,997069,935062,222727,346001,498635,761765,363597,511075,883994,232905,51315,769265,747463,52722,565102,440131,96584,48959,35930,25841,684164,397824,758902,378047,689435,510740,715025,892593,412900,904273,211991,857771,400276,360163,839325,623792,516054,887697,176941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]