SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505118 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505118 [ RunTime:0.002338s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (895168,143997,399655,536424,127952,746684,836147,896825,233740,950977,406678,645268,986523,462365,997753,426089,215918,126593,568749,1004652,561895,1030522,257545,845560,580331,991956,331030,682491,20196,328584,928842,621925,170001,125529,549998,1023158,135301,725721,413103,898839,230738,643309,939911,652288,373900,847629,898335,922369,505830,698984,555350,700516,347976,656834,456206,375696,285429,310634,1046367,39540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003650s ]