SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419395 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419395 [ RunTime:0.001486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (756066,437640,444387,938087,268451,52834,215210,943864,459413,231456,777302,628689,426123,743720,111824,374867,511934,742402,517215,403584,487918,332251,1018171,405569,671597,808988,102656,821112,589213,499805,954528,38355,445489,471725,847762,615256,721163,151824,720932,781005,367740,607878,688498,536703,304730,610273,346399,820688,740595,782517,508873,935500,709897,140653,470731,790614,21795,295703,69096,489699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419395 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419395 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]