SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439220 LIMIT 1 [ RunTime:0.000487s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439220 [ RunTime:0.002004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424108,10692,3996,969088,881764,174839,402701,307917,854662,79954,35784,700068,29960,482451,294949,300051,281986,374019,988817,57532,994720,938067,223346,95838,861532,883721,338755,568987,1029105,403610,843870,840310,533970,427475,246106,1003264,540004,41176,1024663,133144,704536,168331,649256,129365,204566,376350,348660,431883,197334,104134,510324,899699,23876,1006818,293293,686663,343437,79731,777422,176997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]